Skip Headers

Oracle® Data Provider for .NET Developer's Guide 10g Release 2 (10.2) Part Number B14307-01 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# OracleIntervalDS Structure

The `OracleIntervalDS` structure represents the Oracle `INTERVAL` `DAY` `TO` `SECOND` datatype to be stored in or retrieved from a database. Each `OracleIntervalDS` stores a period of time in term of days, hours, minutes, seconds, and fractional seconds.

Class Inheritance

`Object`

`ValueType`

`OracleIntervalDS`

Declaration

    // C#
    public struct OracleIntervalDS : IComparable

Thread Safety

All public static methods are thread-safe, although instance methods do not guarantee thread safety.

Example

    // C#

    using System;
    using Oracle.DataAccess.Types;

    class OracleIntervalDSSample
    {
      static void Main()
      {
        OracleIntervalDS iDSMax = OracleIntervalDS.MaxValue;
        double totalDays = iDSMax.TotalDays;

        totalDays -= 1;
        OracleIntervalDS iDSMax_1 = new OracleIntervalDS(totalDays);

        // Calculate the difference
        OracleIntervalDS iDSDiff = iDSMax - iDSMax_1;

        // Prints "iDSDiff.ToString() = +000000000 23:59:59.999999999"
        Console.WriteLine("iDSDiff.ToString() = " + iDSDiff.ToString());
      }
    }

Requirements

Namespace: `Oracle.DataAccess.Types`

Assembly: `Oracle.DataAccess.dll`

See Also: "Oracle.DataAccess.Types Namespace" OracleIntervalDS Members OracleIntervalDS Constructors OracleIntervalDS Static Fields OracleIntervalDS Static Methods OracleIntervalDS Static Operators OracleIntervalDS Type Conversions OracleIntervalDS Properties OracleIntervalDS Methods

## OracleIntervalDS Members

`OracleIntervalDS` members are listed in the following tables:

OracleIntervalDS Constructors

`OracleIntervalDS` constructors are listed in Table 11-48

Table 11-48 OracleIntervalDS Constructors

Constructor | Description
--- | ---
OracleIntervalDS Constructors | Instantiates a new instance of `OracleIntervalDS` structure (Overloaded)

OracleIntervalDS Static Fields

The `OracleIntervalDS` static fields are listed in Table 11-49.

Table 11-49 OracleIntervalDS Static Fields

Field | Description
--- | ---
MaxValue | Represents the maximum valid time interval for an `OracleIntervalDS` structure
MinValue | Represents the minimum valid time interval for an `OracleIntervalDS` structure
Null | Represents a null value that can be assigned to an `OracleIntervalDS` instance
Zero | Represents a zero value for an `OracleIntervalDS` structure

OracleIntervalDS Static Methods

The `OracleIntervalDS` static methods are listed in Table 11-50.

Table 11-50 OracleIntervalDS Static Methods

Methods | Description
--- | ---
Equals | Determines whether or not two `OracleIntervalDS` values are equal (Overloaded)
GreaterThan | Determines whether or not one `OracleIntervalDS` value is greater than another
GreaterThanOrEqual | Determines whether or not one `OracleIntervalDS` value is greater than or equal to another
LessThan | Determines whether or not one `OracleIntervalDS` value is less than another
LessThanOrEqual | Determines whether or not one `OracleIntervalDS` value is less than or equal to another
NotEquals | Determines whether or not two `OracleIntervalDS` values are not equal
Parse | Returns an `OracleIntervalDS` structure and sets its value for time interval using a string
SetPrecision | Returns a new instance of an `OracleIntervalDS` with the specified day precision and fractional second precision

OracleIntervalDS Static Operators

The `OracleIntervalDS` static operators are listed in Table 11-51.

Table 11-51 OracleIntervalDS Static Operators

Operator | Description
--- | ---
operator + | Adds two `OracleIntervalDS` values
operator == | Determines whether or not two `OracleIntervalDS` values are equal
operator > | Determines whether or not one `OracleIntervalDS` value is greater than another
operator >= | Determines whether or not one `OracleIntervalDS` value is greater than or equal to another
operator != | Determines whether or not two `OracleIntervalDS` values are not equal
operator < | Determines whether or not one `OracleIntervalDS` value is less than another
operator <= | Determines whether or not one `OracleIntervalDS` value is less than or equal to another
operator - | Subtracts one `OracleIntervalDS` value from another
operator - | Negates an `OracleIntervalDS` structure
operator * | Multiplies an `OracleIntervalDS` value by a number
operator / | Divides an `OracleIntervalDS` value by a number

OracleIntervalDS Type Conversions

The `OracleIntervalDS` type conversions are listed in Table 11-52.

Table 11-52 OracleIntervalDS Type Conversions

Operator | Description
--- | ---
explicit operator TimeSpan | Converts an `OracleIntervalDS` structure to a `TimeSpan` structure
explicit operator OracleIntervalDS | Converts a string to an `OracleIntervalDS` structure
implicit operator OracleIntervalDS | Converts a `TimeSpan` structure to an `OracleIntervalDS` structure

OracleIntervalDS Properties

The `OracleIntervalDS` properties are listed in Table 11-53.

Table 11-53 OracleIntervalDS Properties

Properties | Description
--- | ---
BinData | Returns an array of bytes that represents the Oracle `INTERVAL` `DAY` `TO` `SECOND` in Oracle internal format
Days | Gets the days component of an `OracleIntervalDS`
Hours | Gets the hours component of an `OracleIntervalDS`
IsNull | Indicates whether or not the current instance has a null value
Milliseconds | Gets the milliseconds component of an `OracleIntervalDS`
Minutes | Gets the minutes component of an `OracleIntervalDS`
Nanoseconds | Gets the nanoseconds component of an `OracleIntervalDS`
Seconds | Gets the seconds component of an `OracleIntervalDS`
TotalDays | Returns the total number, in days, that represent the time period in the `OracleIntervalDS` structure
Value | Specifies the time interval that is stored in the `OracleIntervalDS` structure

OracleIntervalDS Methods

The `OracleIntervalDS` methods are listed in Table 11-54.

Table 11-54 OracleIntervalDS Methods

Methods | Description
--- | ---
CompareTo | Compares the current `OracleIntervalDS` instance to an object, and returns an integer that represents their relative values
Equals | Determines whether or not the specified `object` has the same time interval as the current instance (Overloaded)
GetHashCode | Returns a hash code for the `OracleIntervalDS` instance
GetType | Inherited from `Object`
ToString | Converts the current `OracleIntervalDS` structure to a string

See Also: "Oracle.DataAccess.Types Namespace" OracleIntervalDS Structure

## OracleIntervalDS Constructors

`OracleIntervalDS` constructors create a new instance of the `OracleIntervalDS` structure.

Overload List:

- OracleIntervalDS(TimeSpan)

  This constructor creates a new instance of the `OracleIntervalDS` structure and sets its value using a `TimeSpan` structure.

- OracleIntervalDS(string)

  This constructor creates a new instance of the `OracleIntervalDS` structure and sets its value using a string that indicates a period of time.

- OracleIntervalDS(double)

  This constructor creates a new instance of the `OracleIntervalDS` structure and sets its value using the total number of days.

- OracleIntervalDS(int, int, int, int, double)

  This constructor creates a new instance of the `OracleIntervalDS` structure and sets its value using the supplied days, hours, minutes, seconds and milliseconds.

- OracleIntervalDS(int, int, int, int, int)

  This constructor creates a new instance of the `OracleIntervalDS` structure and sets its value using the supplied days, hours, minutes, seconds, and nanoseconds.

- OracleIntervalDS(byte[ ])

  This constructor creates a new instance of the `OracleIntervalDS` structure and sets its value to the provided byte array, which is in an internal Oracle `INTERVAL` `DAY` `TO` `SECOND` format.

See Also: "Oracle.DataAccess.Types Namespace" OracleIntervalDS Structure OracleIntervalDS Members

### OracleIntervalDS(TimeSpan)

This constructor creates a new instance of the `OracleIntervalDS` structure and sets its value using a `TimeSpan` structure.

Declaration

    // C#
    public OracleIntervalDS(TimeSpan ts);

Parameters

- `ts`

  A `TimeSpan` structure.

See Also: "Oracle.DataAccess.Types Namespace" OracleIntervalDS Structure OracleIntervalDS Members

### OracleIntervalDS(string)

This constructor creates a new instance of the `OracleIntervalDS` structure and sets its value using a string that indicates a period of time.

Declaration

    // C#
    public OracleIntervalDS(string intervalStr);

Parameters

- `intervalStr`

  A string representing the Oracle `INTERVAL` `DAY` `TO` `SECOND`.

Exceptions

`ArgumentException` - The `intervalStr` parameter is not in the valid format or has an invalid value.

`ArgumentNullException` - The `intervalStr` parameter is null.

Remarks

The value specified in the supplied `intervalStr` must be in Day HH:MI:SSxFF format.

Example

"1 2:3:4.99" means 1 day, 2 hours, 3 minutes, 4 seconds, and 990 milliseconds or 1 day, 2 hours, 3 minutes, 4 seconds, and 990000000 nanoseconds.

See Also: "Oracle.DataAccess.Types Namespace" OracleIntervalDS Structure OracleIntervalDS Members

### OracleIntervalDS(double)

This constructor creates a new instance of the `OracleIntervalDS` structure and sets its value using the total number of days.

Declaration

    // C#
    public OracleIntervalDS(double totalDays);

Parameters

- `totalDays`

  The supplied total number of days for a time interval. Range of days is -1000,000,000 < `totalDays` < 1000,000,000.

Exceptions

`ArgumentOutOfRangeException` - The argument value for one or more of the parameters is out of the specified range.

`ArgumentException` - The argument values of the parameters cannot be used to construct a valid `OracleIntervalDS`.

See Also: "Oracle.DataAccess.Types Namespace" OracleIntervalDS Structure OracleIntervalDS Members

### OracleIntervalDS(int, int, int, int, double)

This constructor creates a new instance of the `OracleIntervalDS` structure and sets its value using the supplied days, hours, minutes, seconds, and milliseconds.

Declaration

    // C#
    public OracleIntervalDS (int days, int hours, int minutes, int seconds,
       double milliSeconds);

Parameters

- `days`

  The days provided. Range of day is (-999,999,999 to 999,999,999).

- `hours`

  The hours provided. Range of hour is (-23 to 23).

- `minutes`

  The minutes provided. Range of minute is (-59 to 59).

- `seconds`

  The seconds provided. Range of second is (-59 to 59).

- `milliSeconds`

  The milliseconds provided. Range of millisecond is (- 999.999999 to 999.999999).

Exceptions

`ArgumentOutOfRangeException` - The argument value for one or more of the parameters is out of the specified range.

`ArgumentException` - The argument values of the parameters cannot be used to construct a valid `OracleIntervalDS`.

Remarks

The sign of all the arguments must be the same.

See Also: "Oracle.DataAccess.Types Namespace" OracleIntervalDS Structure OracleIntervalDS Members

### OracleIntervalDS(int, int, int, int, int)

This constructor creates a new instance of the `OracleIntervalDS` structure and sets its value using the supplied days, hours, minutes, seconds, and nanoseconds.

Declaration

    // C#
    public OracleIntervalDS (int days, int hours, int minutes, int seconds,
       int nanoseconds);

Parameters

- `days`

  The days provided. Range of day is (-999,999,999 to 999,999,999).

- `hours`

  The hours provided. Range of hour is (-23 to 23).

- `minutes`

  The minutes provided. Range of minute is (-59 to 59).

- `seconds`

  The seconds provided. Range of second is (-59 to 59).

- `nanoseconds`

  The nanoseconds provided. Range of nanosecond is (-999,999,999 to 999,999,999)

Exceptions

`ArgumentOutOfRangeException` - The argument value for one or more of the parameters is out of the specified range.

`ArgumentException` - The argument values of the parameters cannot be used to construct a valid `OracleIntervalDS`.

Remarks

The sign of all the arguments must be the same.

See Also: "Oracle.DataAccess.Types Namespace" OracleIntervalDS Structure OracleIntervalDS Members

### OracleIntervalDS(byte[ ])

This constructor creates a new instance of the `OracleIntervalDS` structure and sets its value to the provided byte array, which is in an internal Oracle `INTERVAL` `DAY` `TO` `SECOND` format.

Declaration

    // C#
    public OracleIntervalDS (byte[ ] bytes);

Parameters

- `bytes`

  A byte array that is in an internal Oracle `INTERVAL` `DAY` `TO` `SECOND` format.

Exceptions

`ArgumentException` - `bytes` is not in internal Oracle `INTERVAL` `DAY` `TO` `SECOND` format, or `bytes` is not a valid Oracle `INTERVAL` `DAY` `TO` `SECOND`.

`ArgumentNullException` - `bytes` is null.

See Also: "Oracle.DataAccess.Types Namespace" OracleIntervalDS Structure OracleIntervalDS Members

## OracleIntervalDS Static Fields

The `OracleIntervalDS` static fields are listed in Table 11-55.

Table 11-55 OracleIntervalDS Static Fields

Field | Description
--- | ---
MaxValue | Represents the maximum valid time interval for an `OracleIntervalDS` structure
MinValue | Represents the minimum valid time interval for an `OracleIntervalDS` structure
Null | Represents a null value that can be assigned to an `OracleIntervalDS` instance
Zero | Represents a zero value for an `OracleIntervalDS` structure

See Also: "Oracle.DataAccess.Types Namespace" OracleIntervalDS Structure OracleIntervalDS Members

### MaxValue

This static field represents the maximum value for an `OracleIntervalDS` structure.

Declaration

    // C#
    public static readonly OracleIntervalDS MaxValue;

Remarks

Maximum values:

- Day: 999999999

- hour: 23

- minute is 59

- second: 59

- nanosecond: 999999999

See Also: "Oracle.DataAccess.Types Namespace" OracleIntervalDS Structure OracleIntervalDS Members

### MinValue

This static field represents the minimum value for an `OracleIntervalDS` structure.

Declaration

    // C#
    public static readonly OracleIntervalDS MinValue;

Remarks

Minimum values:

- Day: -999999999

- hour: -23

- minute: -59

- second: -59

- nanosecond: -999999999

See Also: "Oracle.DataAccess.Types Namespace" OracleIntervalDS Structure OracleIntervalDS Members

### Null

This static field represents a null value that can be assigned to an `OracleIntervalDS` instance.

Declaration

    // C#
    public static readonly OracleIntervalDS Null;

See Also: "Oracle.DataAccess.Types Namespace" OracleIntervalDS Structure OracleIntervalDS Members

### Zero

This static field represents a zero value for an `OracleIntervalDS` structure.

Declaration

    // C#
    public static readonly OracleIntervalDS Zero;

See Also: "Oracle.DataAccess.Types Namespace" OracleIntervalDS Structure OracleIntervalDS Members

## OracleIntervalDS Static Methods

The `OracleIntervalDS` static methods are listed in Table 11-56.

Table 11-56 OracleIntervalDS Static Methods

Methods | Description
--- | ---
Equals | Determines whether or not two `OracleIntervalDS` values are equal (Overloaded)
GreaterThan | Determines whether or not one `OracleIntervalDS` value is greater than another
GreaterThanOrEqual | Determines whether or not one `OracleIntervalDS` value is greater than or equal to another
LessThan | Determines whether or not one `OracleIntervalDS` value is less than another
LessThanOrEqual | Determines whether or not one `OracleIntervalDS` value is less than or equal to another
NotEquals | Determines whether or not two `OracleIntervalDS` values are not equal
Parse | Returns an `OracleIntervalDS` structure and sets its value for time interval using a string
SetPrecision | Returns a new instance of an `OracleIntervalDS` with the specified day precision and fractional second precision

See Also: "Oracle.DataAccess.Types Namespace" OracleIntervalDS Structure OracleIntervalDS Members

### Equals

This static method determines whether or not two `OracleIntervalDS` values are equal.

Declaration

    // C#
    public static bool Equals(OracleIntervalDS val1, OracleIntervalDS val2);

Parameters

- `val1`

  The first `OracleIntervalDS`.

- `val2`

  The second `OracleIntervalDS`.

Return Value

If the two `OracleIntervalDS` structures represent the same time interval, returns `true`; otherwise, returns `false`.

Remarks

The following rules apply to the behavior of this method.

- Any `OracleIntervalDS` that has a value compares greater than an `OracleIntervalDS` that has a null value.

- Two `OracleIntervalDS`s that contain a null value are equal.

See Also: "Oracle.DataAccess.Types Namespace" OracleIntervalDS Structure OracleIntervalDS Members

### GreaterThan

This static method determines whether or not the first of two `OracleIntervalDS` values is greater than the second.

Declaration

    // C#
    public static bool GreaterThan(OracleIntervalDS val1, OracleIntervalDS
       val2);

Parameters

- `val1`

  The first `OracleIntervalDS`.

- `val2`

  The second `OracleIntervalDS`.

Return Value

Returns `true` if the first of two `OracleIntervalDS` values is greater than the second; otherwise, returns `false`.

Remarks

The following rules apply to the behavior of this method.

- Any `OracleIntervalDS` that has a value compares greater than an `OracleIntervalDS` that has a null value.

- Two `OracleIntervalDS`s that contain a null value are equal.

See Also: "Oracle.DataAccess.Types Namespace" OracleIntervalDS Structure OracleIntervalDS Members

### GreaterThanOrEqual

This static method determines whether or not the first of two `OracleIntervalDS` values is greater than or equal to the second.

Declaration

    // C#
    public static bool GreaterThanOrEqual(OracleIntervalDS val1,
      OracleIntervalDS val2);

Parameters

- `val1`

  The first `OracleIntervalDS`.

- `val2`

  The second `OracleIntervalDS`.

Return Value

Returns `true` if the first of two `OracleIntervalDS` values is greater than or equal to the second; otherwise, returns `false`.

Remarks

The following rules apply to the behavior of this method.

- Any `OracleIntervalDS` that has a value compares greater than an `OracleIntervalDS` that has a null value.

- Two `OracleIntervalDS`s that contain a null value are equal.

See Also: "Oracle.DataAccess.Types Namespace" OracleIntervalDS Structure OracleIntervalDS Members

### LessThan

This static method determines whether or not the first of two `OracleIntervalDS` values is less than the second.

Declaration

    // C#
    public static bool LessThan(OracleIntervalDS val1, OracleIntervalDS val2);

Parameters

- `val1`

  The first `OracleIntervalDS`.

- `val2`

  The second `OracleIntervalDS`.

Return Value

Returns `true` if the first of two `OracleIntervalDS` values is less than the second; otherwise, returns `false`.

Remarks

The following rules apply to the behavior of this method.

- Any `OracleIntervalDS` that has a value compares greater than an `OracleIntervalDS` that has a null value.

- Two `OracleIntervalDS`s that contain a null value are equal.

See Also: "Oracle.DataAccess.Types Namespace" OracleIntervalDS Structure OracleIntervalDS Members

### LessThanOrEqual

This static method determines whether or not the first of two `OracleIntervalDS` values is less than or equal to the second.

Declaration

    // C#
    public static bool LessThanOrEqual(OracleIntervalDS val1, OracleIntervalDS val2);

Parameters

- `val1`

  The first `OracleIntervalDS`.

- `val2`

  The second `OracleIntervalDS`.

Return Value

Returns `true` if the first of two `OracleIntervalDS` values is less than or equal to the second; otherwise, returns `false`.

Remarks

The following rules apply to the behavior of this method.

- Any `OracleIntervalDS` that has a value compares greater than an `OracleIntervalDS` that has a null value.

- Two `OracleIntervalDS`s that contain a null value are equal.

See Also: "Oracle.DataAccess.Types Namespace" OracleIntervalDS Structure OracleIntervalDS Members

### NotEquals

This static method determines whether or not two `OracleIntervalDS` values are not equal.

Declaration

    // C#
    public static bool NotEquals(OracleIntervalDS val1, OracleIntervalDS val2);

Parameters

- `val1`

  The first `OracleIntervalDS`.

- `val2`

  The second `OracleIntervalDS`.

Return Value

Returns `true` if two `OracleIntervalDS` values are not equal; otherwise, returns `false`.

Remarks

The following rules apply to the behavior of this method.

- Any `OracleIntervalDS` that has a value compares greater than an `OracleIntervalDS` that has a null value.

- Two `OracleIntervalDS`s that contain a null value are equal.

See Also: "Oracle.DataAccess.Types Namespace" OracleIntervalDS Structure OracleIntervalDS Members

### Parse

This static method returns an `OracleIntervalDS` instance and sets its value for time interval using a string.

Declaration

    // C#
    public static OracleIntervalDS Parse(string intervalStr);

Parameters

- `intervalStr`

  A string representing the Oracle `INTERVAL` `DAY` `TO` `SECOND`.

Return Value

Returns an `OracleIntervalDS` instance representing the time interval from the supplied string.

Exceptions

`ArgumentException` - The `intervalStr` parameter is not in the valid format or `intervalStr` has an invalid value.

`ArgumentNullException` - The `intervalStr` parameter is null.

Remarks

The value specified in `intervalStr` must be in Day HH:MI:SSxFF format.

Example

"`1` `2:3:4.99`" means 1 day, 2 hours, 3 minutes, 4 seconds, and 990 milliseconds or 1 day, 2 hours, 3 minutes, 4 seconds, and 990000000 nanoseconds.

See Also: "Oracle.DataAccess.Types Namespace" OracleIntervalDS Structure OracleIntervalDS Members

### SetPrecision

This static method returns a new instance of an `OracleIntervalDS` with the specified day precision and fractional second precision.

Declaration

    // C#
    public static OracleIntervalDS SetPrecision(OracleIntervalDS value1,
        int dayPrecision, int fracSecPrecision);

Parameters

- `value1`

  An `OracleIntervalDS` structure.

- `dayPrecision`

  The day precision provided. Range of day precision is (0 to 9).

- `fracSecPrecision`

  The fractional second precision provided. Range of fractional second precision is (0 to 9).

Return Value

An `OracleIntervalDS` instance.

Exceptions

`ArgumentOutOfRangeException` - An argument value is out of the specified range.

Remarks

Depending on the value specified in the supplied `dayPrecision`, 0 or more leading zeros are displayed in the string returned by `ToString()`.

The value specified in the supplied `fracSecPrecision` is used to perform a rounding off operation on the supplied `OracleIntervalDS` value. Depending on this value, `0` or more trailing zeros are displayed in the string returned by `ToString()`.

Example

The `OracleIntervalDS` with a value of "`1` `2:3:4.99`" results in the string "`001` `2:3:4.99000`" when `SetPrecision()` is called, with the day precision set to `3` and fractional second precision set to `5`.

See Also: "Oracle.DataAccess.Types Namespace" OracleIntervalDS Structure OracleIntervalDS Members

## OracleIntervalDS Static Operators

The `OracleIntervalDS` static operators are listed in Table 11-57.

Table 11-57 OracleIntervalDS Static Operators

Operator | Description
--- | ---
operator + | Adds two `OracleIntervalDS` values
operator == | Determines whether or not two `OracleIntervalDS` values are equal
operator > | Determines whether or not one `OracleIntervalDS` value is greater than another
operator >= | Determines whether or not one `OracleIntervalDS` value is greater than or equal to another
operator != | Determines whether or not two `OracleIntervalDS` values are not equal
operator < | Determines whether or not one `OracleIntervalDS` value is less than another
operator <= | Determines whether or not one `OracleIntervalDS` value is less than or equal to another
operator - | Subtracts one `OracleIntervalDS` value from another
operator - | Negates an `OracleIntervalDS` structure
operator * | Multiplies an `OracleIntervalDS` value by a number
operator / | Divides an `OracleIntervalDS` value by a number

See Also: "Oracle.DataAccess.Types Namespace" OracleIntervalDS Structure OracleIntervalDS Members

### operator +

This static operator adds two `OracleIntervalDS` values.

Declaration

    // C#
    public static OracleIntervalDS operator + (OracleIntervalDS val1,
       OracleIntervalDS val2);

Parameters

- `val1`

  The first `OracleIntervalDS`.

- `val2`

  The second `OracleIntervalDS`.

Return Value

An `OracleIntervalDS.`

Remarks

If either argument has a null value, the returned `OracleIntervalDS` structure has a null value.

See Also: "Oracle.DataAccess.Types Namespace" OracleIntervalDS Structure OracleIntervalDS Members

### operator ==

This static operator determines if two `OracleIntervalDS` values are equal.

Declaration

    // C#
    public static bool operator == (OracleIntervalDS val1,
        OracleIntervalDS val2);

Parameters

- `val1`

  The first `OracleIntervalDS`.

- `val2`

  The second `OracleIntervalDS`.

Return Value

Returns `true` if the two `OracleIntervalDS` values are the same; otherwise returns `false`.

Remarks

The following rules apply to the behavior of this method.

- Any `OracleIntervalDS` that has a value compares greater than an `OracleIntervalDS` that has a null value.

- Two `OracleIntervalDS`s that contain a null value are equal.

See Also: "Oracle.DataAccess.Types Namespace" OracleIntervalDS Structure OracleIntervalDS Members

### operator >

This static operator determines if the first of two `OracleIntervalDS` values is greater than the second.

Declaration

    // C#
    public static bool operator > (OracleIntervalDS val1,
       OracleIntervalDS val2);

Parameters

- `val1`

  The first `OracleIntervalDS`.

- `val2`

  The second `OracleIntervalDS`.

Return Value

Returns `true` if one `OracleIntervalDS` value is greater than another; otherwise, returns `false`.

Remarks

The following rules apply to the behavior of this method.

- Any `OracleIntervalDS` that has a value compares greater than an `OracleIntervalDS` that has a null value.

- Two `OracleIntervalDS`s that contain a null value are equal.

See Also: "Oracle.DataAccess.Types Namespace" OracleIntervalDS Structure OracleIntervalDS Members

### operator >=

This static operator determines if the first of two `OracleIntervalDS` values is greater than or equal to the second.

Declaration

    // C#
    public static bool operator >= (OracleIntervalDS val1,
      OracleIntervalDS val2);

Parameters

- `val1`

  The first `OracleIntervalDS`.

- `val2`

  The second `OracleIntervalDS`.

Return Value

Returns `true` if the first of two `OracleIntervalDS` values is greater than or equal to the second; otherwise, returns `false`.

Remarks

The following rules apply to the behavior of this method.

- Any `OracleIntervalDS` that has a value compares greater than an `OracleIntervalDS` that has a null value.

- Two `OracleIntervalDS`s that contain a null value are equal.

See Also: "Oracle.DataAccess.Types Namespace" OracleIntervalDS Structure OracleIntervalDS Members

### operator !=

This static operator determines if the two `OracleIntervalDS` values are not equal.

Declaration

    // C#
    public static bool operator != (OracleIntervalDS val1,
      OracleIntervalDS val2);

Parameters

- `val1`

  The first `OracleIntervalDS`.

- `val2`

  The second `OracleIntervalDS`.

Return Value

Returns `true` if the two `OracleIntervalDS` values are not equal; otherwise, returns `false`.

Remarks

The following rules apply to the behavior of this method.

- Any `OracleIntervalDS` that has a value compares greater than an `OracleIntervalDS` that has a null value.

- Two `OracleIntervalDS`s that contain a null value are equal.

See Also: "Oracle.DataAccess.Types Namespace" OracleIntervalDS Structure OracleIntervalDS Members

### operator <

This static operator determines if the first of two `OracleIntervalDS` values is less than the second.

Declaration

    // C#
    public static bool operator < (OracleIntervalDS val1,
      OracleIntervalDS val2);

Parameters

- `val1`

  The first `OracleIntervalDS`.

- `val2`

  The second `OracleIntervalDS`.

Return Value

Returns `true` if the first of two `OracleIntervalDS` values is less than the second; otherwise, returns `false`.

Remarks

The following rules apply to the behavior of this method.

- Any `OracleIntervalDS` that has a value compares greater than an `OracleIntervalDS` that has a null value.

- Two `OracleIntervalDS`s that contain a null value are equal.

See Also: "Oracle.DataAccess.Types Namespace" OracleIntervalDS Structure OracleIntervalDS Members

### operator <=

This static operator determines if the first of two `OracleIntervalDS` values is less than or equal to the second.

Declaration

    // C#
    public static bool operator <= (OracleIntervalDS val1,
       OracleIntervalDS val2);

Parameters

- `val1`

  The first `OracleIntervalDS`.

- `val2`

  The second `OracleIntervalDS`.

Return Value

Returns `true` if the first of two `OracleIntervalDS` values is less than or equal to the second; otherwise, returns `false`.

Remarks

The following rules apply to the behavior of this method.

- Any `OracleIntervalDS` that has a value compares greater than an `OracleIntervalDS` that has a null value.

- Two `OracleIntervalDS`s that contain a null value are equal.

See Also: "Oracle.DataAccess.Types Namespace" OracleIntervalDS Structure OracleIntervalDS Members

### operator -

This static operator subtracts one `OracleIntervalDS` structure from another.

Declaration

    // C#
    public static OracleIntervalDS operator - (OracleIntervalDS val1,
       OracleIntervalDS val2);

Parameters

- `val1`

  The first `OracleIntervalDS`.

- `val2`

  The second `OracleIntervalDS`.

Return Value

An `OracleIntervalDS` structure.

Remarks

If either argument has a null value, the returned `OracleIntervalDS` structure has a null value.

See Also: "Oracle.DataAccess.Types Namespace" OracleIntervalDS Structure OracleIntervalDS Members

### operator -

This static operator negates the supplied `OracleIntervalDS` structure.

Declaration

    // C#
    public static OracleIntervalDS operator - (OracleIntervalDS val);

Parameters

- `val`

  An `OracleIntervalDS`.

Return Value

An `OracleIntervalDS` structure.

Remarks

If the supplied `OracleIntervalDS` structure has a null value, the returned `OracleIntervalDS` structure has a null value.

See Also: "Oracle.DataAccess.Types Namespace" OracleIntervalDS Structure OracleIntervalDS Members

### operator *

This static operator multiplies an `OracleIntervalDS` value by a number.

Declaration

    // C#
    public static OracleIntervalDS operator * (OracleIntervalDS val1,
       int multiplier);

Parameters

- `val1`

  The first `OracleIntervalDS`.

- `multiplier`

  A multiplier.

Return Value

A new `OracleIntervalDS` instance.

Remarks

If the `OracleIntervalDS` structure has a null value, the returned `OracleIntervalDS` structure has a null value.

See Also: "Oracle.DataAccess.Types Namespace" OracleIntervalDS Structure OracleIntervalDS Members

### operator /

This static operator divides an `OracleIntervalDS` value by a number.

Declaration

    // C#
    public static OracleIntervalDS operator / (OracleIntervalDS val1,
       int divisor);

Parameters

- `val1`

  The first `OracleIntervalDS`.

- `divisor`

  A divisor.

Return Value

An `OracleIntervalDS` structure.

Remarks

If the `OracleIntervalDS` structure has a null value, the returned `OracleIntervalDS` structure has a null value.

See Also: "Oracle.DataAccess.Types Namespace" OracleIntervalDS Structure OracleIntervalDS Members

## OracleIntervalDS Type Conversions

The `OracleIntervalDS` type conversions are listed in Table 11-58.

Table 11-58 OracleIntervalDS Type Conversions

Operator | Description
--- | ---
explicit operator TimeSpan | Converts an `OracleIntervalDS` structure to a `TimeSpan` structure
explicit operator OracleIntervalDS | Converts a string to an `OracleIntervalDS` structure
implicit operator OracleIntervalDS | Converts a `TimeSpan` structure to an `OracleIntervalDS` structure

See Also: "Oracle.DataAccess.Types Namespace" OracleIntervalDS Structure OracleIntervalDS Members

### explicit operator TimeSpan

This type conversion operator converts an `OracleIntervalDS` structure to a `TimeSpan` structure.

Declaration

    // C#
    public static explicit operator TimeSpan(OracleIntervalDS val);

Parameters

- `val`

  An `OracleIntervalDS` instance.

Return Value

A `TimeSpan` structure.

Exceptions

`OracleNullValueException` - The `OracleIntervalDS` structure has a null value.

Remarks

See Also: "Oracle.DataAccess.Types Namespace" OracleIntervalDS Structure OracleIntervalDS Members

### explicit operator OracleIntervalDS

This type conversion operator converts a string to an `OracleIntervalDS` structure.

Declaration

    // C#
    public static explicit operator OracleIntervalDS (string intervalStr);

Parameters

- `intervalStr`

  A string representation of an Oracle `INTERVAL` `DAY` `TO` `SECOND`.

Return Value

An `OracleIntervalDS` structure.

Exceptions

`ArgumentException` - The supplied `intervalStr` parameter is not in the correct format or has an invalid value.

`ArgumentNullException` - The `intervalStr` parameter is null.

Remarks

The returned `OracleIntervalDS` structure contains the same time interval represented by the supplied `intervalStr`. The value specified in the supplied `intervalStr` must be in Day HH:MI:SSxFF format.

Example

`"1 2:3:4.99"` means 1 day, 2 hours, 3 minutes 4 seconds and 990 milliseconds or 1 day, 2 hours, 3 minutes 4 seconds and 990000000 nanoseconds.

See Also: "Oracle.DataAccess.Types Namespace" OracleIntervalDS Structure OracleIntervalDS Members

### implicit operator OracleIntervalDS

This type conversion operator converts a `TimeSpan` structure to an `OracleIntervalDS` structure.

Declaration

    // C#
    public static implicit operator OracleIntervalDS(TimeSpan val);

Parameters

- `val`

  A `TimeSpan` instance.

Return Value

An `OracleIntervalDS` structure.

Remarks

The returned `OracleIntervalDS` structure contains the same days, hours, seconds, and milliseconds as the supplied `TimeSpan` `val`.

See Also: "Oracle.DataAccess.Types Namespace" OracleIntervalDS Structure OracleIntervalDS Members

## OracleIntervalDS Properties

The `OracleIntervalDS` properties are listed in Table 11-59.

Table 11-59 OracleIntervalDS Properties

Properties | Description
--- | ---
BinData | Returns an array of bytes that represents the Oracle `INTERVAL` `DAY` `TO` `SECOND` in Oracle internal format
Days | Gets the days component of an `OracleIntervalDS`
Hours | Gets the hours component of an `OracleIntervalDS`
IsNull | Indicates whether or not the current instance has a null value
Milliseconds | Gets the milliseconds component of an `OracleIntervalDS`
Minutes | Gets the minutes component of an `OracleIntervalDS`
Nanoseconds | Gets the nanoseconds component of an `OracleIntervalDS`
Seconds | Gets the seconds component of an `OracleIntervalDS`
TotalDays | Returns the total number, in days, that represent the time period in the `OracleIntervalDS` structure
Value | Specifies the time interval that is stored in the `OracleIntervalDS` structure

See Also: "Oracle.DataAccess.Types Namespace" OracleIntervalDS Structure OracleIntervalDS Members

### BinData

This property returns an array of bytes that represents the Oracle `INTERVAL` `DAY` `TO` `SECOND` in Oracle internal format.

Declaration

    // C#
    public byte[] BinData {get;}

Property Value

A byte array that represents an Oracle `INTERVAL` `DAY` `TO` `SECOND` in Oracle internal format.

Exceptions

`OracleNullValueException` - The current instance has a null value.

Remarks

See Also: "Oracle.DataAccess.Types Namespace" OracleIntervalDS Structure OracleIntervalDS Members

### Days

This property gets the days component of an `OracleIntervalDS`.

Declaration

    // C#
    public int Days {get;}

Property Value

An `int` representing the days component.

Exceptions

`OracleNullValueException` - The current instance has a null value.

See Also: "Oracle.DataAccess.Types Namespace" OracleIntervalDS Structure OracleIntervalDS Members

### Hours

This property gets the hours component of an `OracleIntervalDS.`

Declaration

    // C#
    public int Hours {get;}

Property Value

An `int` representing the hours component.

Exceptions

`OracleNullValueException` - The current instance has a null value.

See Also: "Oracle.DataAccess.Types Namespace" OracleIntervalDS Structure OracleIntervalDS Members

### IsNull

This property indicates whether or not the current instance has a null value.

Declaration

    // C#
    public bool IsNull {get;}

Property Value

Returns `true` if the current instance has a null value; otherwise, returns `false`.

See Also: "Oracle.DataAccess.Types Namespace" OracleIntervalDS Structure OracleIntervalDS Members

### Milliseconds

This property gets the milliseconds component of an `OracleIntervalDS.`

Declaration

    // C#
    public double Milliseconds {get;}

Property Value

A `double` that represents milliseconds component.

Exceptions

`OracleNullValueException` - The current instance has a null value.

See Also: "Oracle.DataAccess.Types Namespace" OracleIntervalDS Structure OracleIntervalDS Members

### Minutes

This property gets the minutes component of an `OracleIntervalDS.`

Declaration

    // C#
    public int Minutes {get;}

Property Value

A `int` that represents minutes component.

Exceptions

`OracleNullValueException` - The current instance has a null value.

See Also: "Oracle.DataAccess.Types Namespace" OracleIntervalDS Structure OracleIntervalDS Members

### Nanoseconds

This property gets the nanoseconds component of an `OracleIntervalDS`.

Declaration

    // C#
    public int Nanoseconds {get;}

Property Value

An `int` that represents nanoseconds component.

Exceptions

`OracleNullValueException` - The current instance has a null value.

See Also: "Oracle.DataAccess.Types Namespace" OracleIntervalDS Structure OracleIntervalDS Members

### Seconds

This property gets the seconds component of an `OracleIntervalDS.`

Declaration

    // C#
    public int Seconds {get;}

Property Value

An `int` that represents seconds component.

Exceptions

`OracleNullValueException` - The current instance has a null value.

See Also: "Oracle.DataAccess.Types Namespace" OracleIntervalDS Structure OracleIntervalDS Members

### TotalDays

This property returns the total number, in days, that represent the time period in the `OracleIntervalDS` structure.

Declaration

    // C#
    public double TotalDays {get;}

Property Value

A `double` that represents the total number of days.

Exceptions

`OracleNullValueException` - The current instance has a null value.

See Also: "Oracle.DataAccess.Types Namespace" OracleIntervalDS Structure OracleIntervalDS Members

### Value

This property specifies the time interval that is stored in the `OracleIntervalDS` structure.

Declaration

    // C#
    public TimeSpan Value {get;}

Property Value

A time interval.

Exceptions

`OracleNullValueException` - The current instance has a null value.

See Also: "Oracle.DataAccess.Types Namespace" OracleIntervalDS Structure OracleIntervalDS Members

## OracleIntervalDS Methods

The `OracleIntervalDS` methods are listed in Table 11-60.

Table 11-60 OracleIntervalDS Methods

Methods | Description
--- | ---
CompareTo | Compares the current `OracleIntervalDS` instance to an object, and returns an integer that represents their relative values
Equals | Determines whether or not the specified `object` has the same time interval as the current instance (Overloaded)
GetHashCode | Returns a hash code for the `OracleIntervalDS` instance
GetType | Inherited from `Object`
ToString | Converts the current `OracleIntervalDS` structure to a string

See Also: "Oracle.DataAccess.Types Namespace" OracleIntervalDS Structure OracleIntervalDS Members

### CompareTo

This method compares the current `OracleIntervalDS` instance to an object, and returns an integer that represents their relative values.

Declaration

    // C#
    public int CompareTo(object obj);

Parameters

- `obj`

  The object being compared to.

Return Value

The method returns:

- Less than zero: if the current `OracleIntervalDS` represents a shorter time interval than `obj`.

- Zero: if the current `OracleIntervalDS` and `obj` represent the same time interval.

- Greater than zero: if the current `OracleIntervalDS` represents a longer time interval than `obj`.

Implements

`IComparable`

Exceptions

`ArgumentException` - The `obj` parameter is not of type `OracleIntervalDS`.

Remarks

The following rules apply to the behavior of this method.

- The comparison must be between `OracleIntervalDS`s. For example, comparing an `OracleIntervalDS` instance with an `OracleBinary` instance is not allowed. When an `OracleIntervalDS` is compared with a different type, an `ArgumentException` is thrown.

- Any `OracleIntervalDS` that has a value compares greater than an `OracleIntervalDS` that has a null value.

- Two `OracleIntervalDS`s that contain a null value are equal.

See Also: "Oracle.DataAccess.Types Namespace" OracleIntervalDS Structure OracleIntervalDS Members

### Equals

This method determines whether or not the specified `object` has the same time interval as the current instance.

Declaration

    // C#
    public override bool Equals(object obj);

Parameters

- `obj`

  The specified object.

Return Value

Returns `true` if `obj` is of type `OracleIntervalDS` and has the same time interval as the current instance; otherwise, returns `false`.

Remarks

The following rules apply to the behavior of this method.

- Any `OracleIntervalDS` that has a value compares greater than an `OracleIntervalDS` that has a null value.

- Two `OracleIntervalDS`s that contain a null value are equal.

See Also: "Oracle.DataAccess.Types Namespace" OracleIntervalDS Structure OracleIntervalDS Members

### GetHashCode

Overrides `Object`

This method returns a hash code for the `OracleIntervalDS` instance.

Declaration

    // C#
    public override int GetHashCode();

See Also: "Oracle.DataAccess.Types Namespace" OracleIntervalDS Structure OracleIntervalDS Members

### ToString

Overrides `Object`

This method converts the current `OracleIntervalDS` structure to a string.

Declaration

    // C#
    public override string ToString();

Return Value

Returns a `string`.

Remarks

If the current instance has a null value, the returned string contains "null".

See Also: "Oracle.DataAccess.Types Namespace" OracleIntervalDS Structure OracleIntervalDS Members